package com.vastcom.sigma.admin.dao;



import com.vastcom.sigma.admin.model.Prohouseid;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

public interface ProhouseidDao extends JpaRepository<Prohouseid,String> {



   @Query("select e from Prohouseid e where e.clqk=:clqk")
    List<Prohouseid> getProhouseidsByClqk(@Param("clqk") String clqk);

   @Query("select e from Prohouseid e where e.scpc=:scpc")
    List<Prohouseid> getProhouseidsByScpc(@Param("scpc") String scpc);

   @Query("select e from Prohouseid e where e.proname =:id")
   Prohouseid getProhouseidByProname(@Param("id")String id);
}
